package comm.dhee.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import comm.dhee.dto.T001T002;

public class TestPR20201 {

	public static void main(String[] args) {

		PR20201DAO pr20201dao = new PR20201DAOImpl();

		try {
			List<String> salJuchuuCodeList = new ArrayList<String>();
			salJuchuuCodeList = pr20201dao.salJuchuuCodeList();
			for (String string : salJuchuuCodeList) {
				System.out.println(string);
			}
			System.out.println("==============================");

			System.out.println(pr20201dao.salKokyakuMei("19000"));
			System.out.println("==============================");

			List<T001T002> juchuuList = new ArrayList<T001T002>();
			juchuuList =pr20201dao.salJuchuuList("11000");
			for (T001T002 t001t002 : juchuuList) {
				System.out.println(t001t002.getJuchuuCode());
				System.out.println(t001t002.getJuchuuHiduke());
				System.out.println(t001t002.getSuuryouTanka());
			}
			System.out.println("==============================");
			
			System.out.println(pr20201dao.salSeikyuushoBangou());
			System.out.println("==============================");

			//			System.out.println(pr20201dao.upSeikyuushoBangou("11100", "001"));
			System.out.println("==============================");

			//			T003 teT003 = new T003();
			//			teT003.setSeikyuushoBangou("003");
			//			teT003.setSeikyuuHiduke("20190111");
			//			System.out.println(pr20201dao.insSeikyuusho(teT003));

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}
